<?php
include_once("../../../php/include_all.php");
$id=$_GET[id];
$kec=get_datas("select distinct (ke.id_kecamatan) , ke.nama_kecamatan from mus_skpd s, mus_usulankecamatan uk, mus_kecamatan ke where uk.id_skpd=s.id_skpd and ke.id_kecamatan=uk.id_kecamatan and s.id_skpd='$id' order by ke.nama_kecamatan asc");
echo "<option value='0'>---Pilih Kecamatan---</option>";
	
foreach ($kec as $kec){
	$idkec=$kec['id_kecamatan'];
	$nmkec=$kec['nama_kecamatan'];
	echo "<option value='$idkec'>$nmkec</option>";
}
?>